package com.shuyu.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.shuyu.domain.ApprovalProcessFlow;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ApprovalProcessFlowMapper extends BaseMapper<ApprovalProcessFlow> {
    @Select("select t1.*,t2.nick_name as username, t3.nick_name as authorization_username  from tbl_approval_process_flow t1 " +
            "left join sys_user t2 on t1.user_id = t2.user_id  " +
            "left join sys_user t3 on t1.authorization_user_id = t3.user_id  " +
            "where t1.detail_id = #{detailId}")
    List<ApprovalProcessFlow> getList(Integer detailId);
}
